Halaman utama Jelajahi Bantuan
Masuk
laisx
/
yilv_new
1
0
Fork 0
Berkas Masalah 0 Permintaan Tarik 0 Wiki
Cabang: master
Ranting Tag
yilv_new
/
AA
/
Report
/
sql
/
[UFMeta]单据数目对照表(11101019).sql

[UFMeta]单据数目对照表(11101019).sql 94 KB
Permalink Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144 
  1. -- UAP报表脚本(数量:  1张 生成时间:2019年11月10日 10:19)
    2. 

  2. --  1.单据数目对照表( 1个视图,项目号U8CUSTDEF)
    3. 

  3. 

  4. -- "单据数目对照表"
    5. 

  5. -- 添加新的UAP报表
    6. 

  6. -- 插入项目信息
    7. 

  7. DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF' 
    8. 

  8. INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/11/10 10:17:23',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
    9. 

  9. GO
    10. 

  10. 

  11. -- UAP报表数据报表级基础信息
    12. 

  12. DELETE FROM UAP_Report WHERE ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' 
    13. 

  13. INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'',N'174df926-9cdb-42db-83e8-557dbc929bbd',N'Function1',N'',N'U8CUSTDEF',N'SA',N'',N'',N'1',N'0',N'demo',N'2019/11/10 10:16:19',N'1',N'',N'',N'',N'1',NULL,NULL,N'1',NULL,N'0',NULL)
    14. 

  14. GO
    15. 

  15. 

  16. DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' AND LocaleID=N'en-US' 
    17. 

  17. INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'en-US',N'单据数目对照表',NULL,N'0')
    18. 

  18. DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' AND LocaleID=N'zh-CN' 
    19. 

  19. INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'zh-CN',N'单据数目对照表',NULL,N'0')
    20. 

  20. DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' AND LocaleID=N'zh-TW' 
    21. 

  21. INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'zh-TW',N'单据数目对照表',NULL,N'0')
    22. 

  22. GO
    23. 

  23. 

  24. DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' 
    25. 

  25. INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'6c420594-068c-4023-b76b-056729798c1b')
    26. 

  26. GO
    27. 

  27. 

  28. -- UAP报表数据源:可能包含进行扩展后的BO对象
    29. 

  29. DELETE FROM BD_BusinessObjects WHERE MetaID=N'174df926-9cdb-42db-83e8-557dbc929bbd' 
    30. 

  30. INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'174df926-9cdb-42db-83e8-557dbc929bbd',N'test(2019-11-10 上午 10:19:45)',N'U8CUSTDEF',N'SA',N'<BusinessObject name="test" description="test" descriptionCN="test" descriptionTW="" descriptionUS="" entityID="">
    31. 

  31. <Function type="Query" name="Function1" description="" descriptionCN="" descriptionTW="" descriptionUS="">
    32. 

  32. <DataQueries><Query name="Query1" querist="SQLQuerist" description="" descriptionCN="" descriptionTW="" descriptionUS="">
    33. 

  33. <Distinct value="False"/><ResultTable name="ResultTable1" description="" descriptionCN="" descriptionTW="" descriptionUS="" >
    34. 

  34. <Column name="单据类型" dataType="String" description="" descriptionCN="" descriptionTW="" descriptionUS=""/>
    35. 

  35. <Column name="开始时间" dataType="String" description="" descriptionCN="" descriptionTW="" descriptionUS=""/>
    36. 

  36. <Column name="截止时间" dataType="String" description="" descriptionCN="" descriptionTW="" descriptionUS=""/>
    37. 

  37. <Column name="下载总数" dataType="Int32" description="" descriptionCN="" descriptionTW="" descriptionUS=""/>
    38. 

  38. </ResultTable><Content type="Script" ToolType="Manual"><Select>Select *from view_counts</Select>
    39. 

  39. <Where></Where>
    40. 

  40. <OrderBy></OrderBy>
    41. 

  41. <GroupBy></GroupBy>
    42. 

  42. <Having></Having>
    43. 

  43. <From></From>
    44. 

  44. </Content>
    45. 

  45. </Query></DataQueries></Function></BusinessObject>',N'test',N'ReportBO',N'',N'0')
    46. 

  46. GO
    47. 

  47. 

  48. -- UAP报表过滤条件
    49. 

  49. 

  50. -- UAP报表添加新的视图
    51. 

  51. -- UAP报表视图级基础信息
    52. 

  52. DELETE FROM UAP_ReportView WHERE ID=N'6c420594-068c-4023-b76b-056729798c1b' 
    53. 

  53. INSERT INTO UAP_ReportView(ID,ReportID,ViewType,Columns,BlandScape,GroupSchemas,PageMargins,PaperType,bSystem,LevelExpend,ViewClass,RowsCount,bShowDetail,PageSetting,Selfaction,PreservedField,CanSaveDefaultFormat,FontColorStyleId,cvieworder,bclassicrptview,reportmergecell)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'A4@#$0',N'0',NULL,N'80,80,80,80',N'9',N'0',NULL,N'',N'40',N'1',NULL,NULL,NULL,N'0',NULL,N'0',N'0',N'0')
    54. 

  54. GO
    55. 

  55. 

  56. DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'en-US' 
    57. 

  57. INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'en-US',N'单据数目对照表',NULL)
    58. 

  58. DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-CN' 
    59. 

  59. INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'zh-CN',N'单据数目对照表',N'1')
    60. 

  60. DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-TW' 
    61. 

  61. INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'zh-TW',N'单据数目对照表',NULL)
    62. 

  62. GO
    63. 

  63. 

  64. 

  65. -- UAP报表视图的格式信息
    66. 

  66. UPDATE UAP_ReportView SET ID=N'6c420594-068c-4023-b76b-056729798c1b',Format=N'<Report Name="Report" Type="1" bPageByGroup="False" SolidGroup="" SolidGroupStyle="0" DesignWidth="0" PageRecords="500" ShowDetail="False" MustShowDetail="False" ViewClass="" FreeViewStyle="1" ReportHeaderOption="0" PrintProvider="0" CanSelectProvider="True" FixedRowsPerPage="0" SolidSort="False" FreeColorStyleID="" SupportDynamicColumn="False" DynamicColumnVisible="False" AllowGroup="True" AllowCross="True" bShowWhenZero="True" BorderStyle="0" BorderColor="-4144960" HelpName="" KeyIndex="" KeyWord="" RowFilter="AAEAAAD/////AQAAAAAAAAAMAgAAAGdVRklEQS5VOC5VQVAuU2VydmljZXMuUmVwb3J0RWxlbWVudHMsIFZlcnNpb249MS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj03OWE0ZTdhZDU0ZWVhYmNhBQEAAAAuVUZJREEuVTguVUFQLlNlcnZpY2VzLlJlcG9ydEVsZW1lbnRzLlJvd0ZpbHRlcgIAAAANX0ZpbHRlclN0cmluZwhfTWFwS2V5cwEBAgAAAAYDAAAAAAkDAAAACw==" bAdjustPrintWidth="True" ReportColorSet="" FilterSource="EmptyColumn"><Section Name="ReportHeader" Type="ReportHeader" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Level="0" bAutoSequence="False"><Control Name="HeaderLabel" Type="CommonLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="黑体" FontSize="20" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="True" /></Section><Section Name="GridDetail" Type="GridDetail" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Level="0"><Control Name="单据类型" Type="GridLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" DataSource="单据类型" Direction="0" Priority="0" LabelType="1" EventType="0" bShowAtReal="False" UserDefineItem="" bMergeCell="False" /><Control Name="开始时间" Type="GridLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" DataSource="开始时间" Direction="0" Priority="0" LabelType="1" EventType="0" bShowAtReal="False" UserDefineItem="" bMergeCell="False" /><Control Name="截止时间" Type="GridLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" DataSource="截止时间" Direction="0" Priority="0" LabelType="1" EventType="0" bShowAtReal="False" UserDefineItem="" bMergeCell="False" /><Control Name="下载总数" Type="GridDecimal" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" CalculateIndex="0" Operator="0" Unit="EmptyColumn" DataSource="下载总数" Precision="0" bShowWhenZero="0" FormatString="" Direction="0" Priority="0" bSummary="True" bClue="False" bColumnSummary="True" bCalcAfterCross="False" EventType="0" bShowAtReal="False" UserDefineItem="" bMergeCell="False" /></Section><Section Name="PageFooter" Type="PageFooter" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Level="0" bAutoSequence="False"><Control Name="Drawing143730" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143731" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Formula="getcopritionname()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143732" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143733" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Formula="getusername()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143736" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143734" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143737" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Formula="page()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143738" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143735" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Formula="date()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143739" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Formula="pages()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143740" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /></Section><DataSource><Column Name="单据类型" Type="String" /><Column Name="开始时间" Type="String" /><Column Name="截止时间" Type="String" /><Column Name="下载总数" Type="Int" /></DataSource></Report>',RuntimeFormat=N'<RuntimeFormat Id=""><RuntimeFormatGroupFormat Id="00000000-0000-0000-0000-000000000001"><RuntimeFormatGroupStyle IsMergeAllCells="False" IsFoldRow="False" Id="Plane.WithDetail"><RuntimeFormatGroupLevel Id="1"><RuntimeFormatGridColumn Width="92" IsVisible="True" IsMerge="False" TextHAlign="1" Position="0" Id="单据类型" /><RuntimeFormatGridColumn Width="192" IsVisible="True" IsMerge="False" TextHAlign="1" Position="1" Id="开始时间" /><RuntimeFormatGridColumn Width="192" IsVisible="True" IsMerge="False" TextHAlign="1" Position="2" Id="截止时间" /><RuntimeFormatGridColumn Width="92" IsVisible="True" IsMerge="False" TextHAlign="3" Position="3" Id="下载总数" /></RuntimeFormatGroupLevel></RuntimeFormatGroupStyle></RuntimeFormatGroupFormat><RuntimeFormatInfo Id="SummaryCols" /></RuntimeFormat>',Chartstring=N'' WHERE ID=N'6c420594-068c-4023-b76b-056729798c1b' 
    67. 

  67. GO
    68. 

  68. 

  69. UPDATE UAP_ReportView_Lang SET ViewID=N'6c420594-068c-4023-b76b-056729798c1b',LocaleID=N'en-US',Format=N'<Report><Section Name="ReportHeader" Type="ReportHeader" Height="140" Caption="报表标题区" IdentityCaption=""><Control Name="HeaderLabel" Type="CommonLabel" X="100" Y="40" Width="280" Height="80" Caption="标题" IdentityCaption="" /></Section><Section Name="GridDetail" Type="GridDetail" Height="140" Caption="明细区" IdentityCaption=""><Control Name="单据类型" Type="GridLabel" X="2" Y="34" Width="96" Height="24" Caption="单据类型" IdentityCaption="" /><Control Name="开始时间" Type="GridLabel" X="98" Y="34" Width="200" Height="24" Caption="开始时间" IdentityCaption="" /><Control Name="截止时间" Type="GridLabel" X="298" Y="34" Width="200" Height="24" Caption="截止时间" IdentityCaption="" /><Control Name="下载总数" Type="GridDecimal" X="498" Y="34" Width="96" Height="24" Caption="下载总数" IdentityCaption="" /></Section><Section Name="PageFooter" Type="PageFooter" Height="140" Caption="页脚区" IdentityCaption=""><Control Name="Drawing143730" Type="CommonLabel" X="9" Y="40" Width="40" Height="20" Caption="单位:" IdentityCaption="单位:" /><Control Name="Drawing143731" Type="Expression" X="53" Y="40" Width="164" Height="20" Caption="GetCopritionName()" IdentityCaption="GetCopritionName()" /><Control Name="Drawing143732" Type="CommonLabel" X="268" Y="40" Width="54" Height="20" Caption="制表人:" IdentityCaption="制表人:" /><Control Name="Drawing143733" Type="Expression" X="324" Y="40" Width="87" Height="20" Caption="GetUserName()" IdentityCaption="GetUserName()" /><Control Name="Drawing143736" Type="CommonLabel" X="427" Y="62" Width="106" Height="20" Caption="【用友】 第" IdentityCaption="【用友】 第" /><Control Name="Drawing143734" Type="CommonLabel" X="493" Y="40" Width="66" Height="20" Caption="打印日期:" IdentityCaption="打印日期:" /><Control Name="Drawing143737" Type="Expression" X="535" Y="62" Width="22" Height="20" Caption="page()" IdentityCaption="page()" /><Control Name="Drawing143738" Type="CommonLabel" X="559" Y="62" Width="45" Height="20" Caption="页,共" IdentityCaption="页,共" /><Control Name="Drawing143735" Type="Expression" X="565" Y="40" Width="84" Height="20" Caption="Date()" IdentityCaption="Date()" /><Control Name="Drawing143739" Type="Expression" X="606" Y="62" Width="23" Height="20" Caption="pages()" IdentityCaption="pages()" /><Control Name="Drawing143740" Type="CommonLabel" X="630" Y="62" Width="19" Height="20" Caption="页" IdentityCaption="页" /></Section><DataSource><Column Name="单据类型" Caption="单据类型" /><Column Name="开始时间" Caption="开始时间" /><Column Name="截止时间" Caption="截止时间" /><Column Name="下载总数" Caption="下载总数" /></DataSource></Report>' WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'en-US' 
    70. 

  70. UPDATE UAP_ReportView_Lang SET ViewID=N'6c420594-068c-4023-b76b-056729798c1b',LocaleID=N'zh-CN',Format=N'<Report><Section Name="ReportHeader" Type="ReportHeader" Height="140" Caption="报表标题区" IdentityCaption=""><Control Name="HeaderLabel" Type="CommonLabel" X="100" Y="40" Width="280" Height="80" Caption="标题" IdentityCaption="" /></Section><Section Name="GridDetail" Type="GridDetail" Height="140" Caption="明细区" IdentityCaption=""><Control Name="单据类型" Type="GridLabel" X="2" Y="34" Width="96" Height="24" Caption="单据类型" IdentityCaption="" /><Control Name="开始时间" Type="GridLabel" X="98" Y="34" Width="200" Height="24" Caption="开始时间" IdentityCaption="" /><Control Name="截止时间" Type="GridLabel" X="298" Y="34" Width="200" Height="24" Caption="截止时间" IdentityCaption="" /><Control Name="下载总数" Type="GridDecimal" X="498" Y="34" Width="96" Height="24" Caption="下载总数" IdentityCaption="" /></Section><Section Name="PageFooter" Type="PageFooter" Height="140" Caption="页脚区" IdentityCaption=""><Control Name="Drawing143730" Type="CommonLabel" X="9" Y="40" Width="40" Height="20" Caption="单位:" IdentityCaption="单位:" /><Control Name="Drawing143731" Type="Expression" X="53" Y="40" Width="164" Height="20" Caption="GetCopritionName()" IdentityCaption="GetCopritionName()" /><Control Name="Drawing143732" Type="CommonLabel" X="268" Y="40" Width="54" Height="20" Caption="制表人:" IdentityCaption="制表人:" /><Control Name="Drawing143733" Type="Expression" X="324" Y="40" Width="87" Height="20" Caption="GetUserName()" IdentityCaption="GetUserName()" /><Control Name="Drawing143736" Type="CommonLabel" X="427" Y="62" Width="106" Height="20" Caption="【用友】 第" IdentityCaption="【用友】 第" /><Control Name="Drawing143734" Type="CommonLabel" X="493" Y="40" Width="66" Height="20" Caption="打印日期:" IdentityCaption="打印日期:" /><Control Name="Drawing143737" Type="Expression" X="535" Y="62" Width="22" Height="20" Caption="page()" IdentityCaption="page()" /><Control Name="Drawing143738" Type="CommonLabel" X="559" Y="62" Width="45" Height="20" Caption="页,共" IdentityCaption="页,共" /><Control Name="Drawing143735" Type="Expression" X="565" Y="40" Width="84" Height="20" Caption="Date()" IdentityCaption="Date()" /><Control Name="Drawing143739" Type="Expression" X="606" Y="62" Width="23" Height="20" Caption="pages()" IdentityCaption="pages()" /><Control Name="Drawing143740" Type="CommonLabel" X="630" Y="62" Width="19" Height="20" Caption="页" IdentityCaption="页" /></Section><DataSource><Column Name="单据类型" Caption="单据类型" /><Column Name="开始时间" Caption="开始时间" /><Column Name="截止时间" Caption="截止时间" /><Column Name="下载总数" Caption="下载总数" /></DataSource></Report>' WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-CN' 
    71. 

  71. UPDATE UAP_ReportView_Lang SET ViewID=N'6c420594-068c-4023-b76b-056729798c1b',LocaleID=N'zh-TW',Format=N'<Report><Section Name="ReportHeader" Type="ReportHeader" Height="140" Caption="报表标题区" IdentityCaption=""><Control Name="HeaderLabel" Type="CommonLabel" X="100" Y="40" Width="280" Height="80" Caption="标题" IdentityCaption="" /></Section><Section Name="GridDetail" Type="GridDetail" Height="140" Caption="明细区" IdentityCaption=""><Control Name="单据类型" Type="GridLabel" X="2" Y="34" Width="96" Height="24" Caption="单据类型" IdentityCaption="" /><Control Name="开始时间" Type="GridLabel" X="98" Y="34" Width="200" Height="24" Caption="开始时间" IdentityCaption="" /><Control Name="截止时间" Type="GridLabel" X="298" Y="34" Width="200" Height="24" Caption="截止时间" IdentityCaption="" /><Control Name="下载总数" Type="GridDecimal" X="498" Y="34" Width="96" Height="24" Caption="下载总数" IdentityCaption="" /></Section><Section Name="PageFooter" Type="PageFooter" Height="140" Caption="页脚区" IdentityCaption=""><Control Name="Drawing143730" Type="CommonLabel" X="9" Y="40" Width="40" Height="20" Caption="单位:" IdentityCaption="单位:" /><Control Name="Drawing143731" Type="Expression" X="53" Y="40" Width="164" Height="20" Caption="GetCopritionName()" IdentityCaption="GetCopritionName()" /><Control Name="Drawing143732" Type="CommonLabel" X="268" Y="40" Width="54" Height="20" Caption="制表人:" IdentityCaption="制表人:" /><Control Name="Drawing143733" Type="Expression" X="324" Y="40" Width="87" Height="20" Caption="GetUserName()" IdentityCaption="GetUserName()" /><Control Name="Drawing143736" Type="CommonLabel" X="427" Y="62" Width="106" Height="20" Caption="【用友】 第" IdentityCaption="【用友】 第" /><Control Name="Drawing143734" Type="CommonLabel" X="493" Y="40" Width="66" Height="20" Caption="打印日期:" IdentityCaption="打印日期:" /><Control Name="Drawing143737" Type="Expression" X="535" Y="62" Width="22" Height="20" Caption="page()" IdentityCaption="page()" /><Control Name="Drawing143738" Type="CommonLabel" X="559" Y="62" Width="45" Height="20" Caption="页,共" IdentityCaption="页,共" /><Control Name="Drawing143735" Type="Expression" X="565" Y="40" Width="84" Height="20" Caption="Date()" IdentityCaption="Date()" /><Control Name="Drawing143739" Type="Expression" X="606" Y="62" Width="23" Height="20" Caption="pages()" IdentityCaption="pages()" /><Control Name="Drawing143740" Type="CommonLabel" X="630" Y="62" Width="19" Height="20" Caption="页" IdentityCaption="页" /></Section><DataSource><Column Name="单据类型" Caption="单据类型" /><Column Name="开始时间" Caption="开始时间" /><Column Name="截止时间" Caption="截止时间" /><Column Name="下载总数" Caption="下载总数" /></DataSource></Report>' WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-TW' 
    72. 

  72. GO
    73. 

  73. 

  74. -- 备份的原始视图格式
    75. 

  75. -- 颜色字体方案
    76. 

  76. -- 功能权限
    77. 

  77. DELETE FROM UAP_ReportView_AuthId WHERE ViewGuid=N'6c420594-068c-4023-b76b-056729798c1b' 
    78. 

  78. INSERT INTO UAP_ReportView_AuthId(ViewGuid,ReportGuid,ReportId,ViewIndex,IsReportApplyAuthControl)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'_6c420594-068c-4023-b76b-056729798c1b',N'1')
    79. 

  79. GO
    80. 

  80. 

  81. -- 视图的字段权限
    82. 

  82. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143731' AND LocaleID=N'en-US' 
    83. 

  83. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143731',NULL,N'1',N'GetCopritionName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    84. 

  84. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143731' AND LocaleID=N'zh-CN' 
    85. 

  85. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143731',NULL,N'1',N'GetCopritionName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    86. 

  86. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143731' AND LocaleID=N'zh-TW' 
    87. 

  87. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143731',NULL,N'1',N'GetCopritionName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    88. 

  88. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143733' AND LocaleID=N'en-US' 
    89. 

  89. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143733',NULL,N'1',N'GetUserName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    90. 

  90. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143733' AND LocaleID=N'zh-CN' 
    91. 

  91. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143733',NULL,N'1',N'GetUserName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    92. 

  92. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143733' AND LocaleID=N'zh-TW' 
    93. 

  93. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143733',NULL,N'1',N'GetUserName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    94. 

  94. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143735' AND LocaleID=N'en-US' 
    95. 

  95. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143735',NULL,N'1',N'Date()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    96. 

  96. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143735' AND LocaleID=N'zh-CN' 
    97. 

  97. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143735',NULL,N'1',N'Date()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    98. 

  98. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143735' AND LocaleID=N'zh-TW' 
    99. 

  99. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143735',NULL,N'1',N'Date()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    100. 

  100. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143737' AND LocaleID=N'en-US' 
    101. 

  101. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143737',NULL,N'1',N'page()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    102. 

  102. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143737' AND LocaleID=N'zh-CN' 
    103. 

  103. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143737',NULL,N'1',N'page()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    104. 

  104. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143737' AND LocaleID=N'zh-TW' 
    105. 

  105. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143737',NULL,N'1',N'page()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    106. 

  106. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143739' AND LocaleID=N'en-US' 
    107. 

  107. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143739',NULL,N'1',N'pages()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    108. 

  108. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143739' AND LocaleID=N'zh-CN' 
    109. 

  109. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143739',NULL,N'1',N'pages()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    110. 

  110. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143739' AND LocaleID=N'zh-TW' 
    111. 

  111. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143739',NULL,N'1',N'pages()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    112. 

  112. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'单据类型' AND LocaleID=N'en-US' 
    113. 

  113. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'单据类型',NULL,N'1',N'单据类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    114. 

  114. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'单据类型' AND LocaleID=N'zh-CN' 
    115. 

  115. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'单据类型',NULL,N'1',N'单据类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    116. 

  116. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'单据类型' AND LocaleID=N'zh-TW' 
    117. 

  117. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'单据类型',NULL,N'1',N'单据类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    118. 

  118. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'截止时间' AND LocaleID=N'en-US' 
    119. 

  119. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'截止时间',NULL,N'1',N'截止时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    120. 

  120. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'截止时间' AND LocaleID=N'zh-CN' 
    121. 

  121. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'截止时间',NULL,N'1',N'截止时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    122. 

  122. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'截止时间' AND LocaleID=N'zh-TW' 
    123. 

  123. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'截止时间',NULL,N'1',N'截止时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    124. 

  124. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'开始时间' AND LocaleID=N'en-US' 
    125. 

  125. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'开始时间',NULL,N'1',N'开始时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    126. 

  126. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'开始时间' AND LocaleID=N'zh-CN' 
    127. 

  127. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'开始时间',NULL,N'1',N'开始时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    128. 

  128. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'开始时间' AND LocaleID=N'zh-TW' 
    129. 

  129. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'开始时间',NULL,N'1',N'开始时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    130. 

  130. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'下载总数' AND LocaleID=N'en-US' 
    131. 

  131. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'下载总数',NULL,N'1',N'下载总数',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    132. 

  132. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'下载总数' AND LocaleID=N'zh-CN' 
    133. 

  133. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'下载总数',NULL,N'1',N'下载总数',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    134. 

  134. DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'下载总数' AND LocaleID=N'zh-TW' 
    135. 

  135. INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'下载总数',NULL,N'1',N'下载总数',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
    136. 

  136. GO
    137. 

  137. 

  138. 

  139. -- 门户菜单相关
    140. 

  140. -- 联查功能
    141. 

  141. 

  142. -- 报表自定义事件
    143. 

  143. 

  144.